﻿<?xml version="1.0" encoding="UTF-8"?>
<form xmlns="http://www.evolutility.com" title="客户产品清单" icon="cube.gif" description="Customers">
  <data dbtable="MRP_Customer" splogin="asp.net membership" dbcolumnpk="ID" dborder="CustomerCode" sppaging="EvoSP_PagedItem @SQLselect, @SQLtable, @SQLfrom, @SQLwhere, @SQLorderby, @SQLpk, @pageid, @pagesize" />
  <panel label="客户列表" width="100">
    <field id="11111" type="text" typeid="5" label="客户编号" dbcolumn="CustomerCode" dbcolumnread="CustomerCode" maxlength="32" readonly="1" required="1" optional="" fpos="10" search="1" searchadv="1" searchlist="1" height="1" width="30" />
    <field id="1" type="text" typeid="5" label="公司名称" dbcolumn="CompanyName" dbcolumnread="CompanyName" maxlength="128" readonly="1" required="1" optional="" fpos="10" search="1" searchadv="1" searchlist="1" height="1" width="30" />
    <field id="2" type="text" typeid="5" label="业务联系人" dbcolumn="FirstContactName" dbcolumnread="FirstContactName" maxlength="64" readonly="1" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="4" type="text" typeid="5" label="业务联系人电话号码" dbcolumn="FirstContactPhone" dbcolumnread="FirstContactPhone" maxlength="50" readonly="1" required="" optional="" fpos="40" search="0" searchadv="1" searchlist="0" height="1" width="20" />
    <field id="134" type="lov" typeid="5" label="结算周期" dbcolumn="PayPeriod" dbcolumnread="PayPeriod1" defaultvalue="1"
dbtablelov="View_PayPeriod_List" dbcolumnreadlov="DisplayText" maxlength="0" readonly="1" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="0" height="1" width="30" />
    <field id="1314" type="lov" typeid="5" label="支付方式" dbcolumn="PaymentType" dbcolumnread="PaymentType1" defaultvalue="1"
dbtablelov="View_PaymentType_List" dbcolumnreadlov="DisplayText" maxlength="0" readonly="1" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="0" height="1" width="30" />
    <field id="2111" type="text" typeid="5" label="财务联系人姓名" dbcolumn="FinanceContactName" dbcolumnread="FinanceContactName" maxlength="64" readonly="1" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="0" height="1" width="20" />
    <field id="4111" type="text" typeid="5" label="财务联系人电话号码" dbcolumn="FinanceContactPhone" dbcolumnread="FinanceContactPhone" maxlength="64" readonly="1" required="" optional="" fpos="40" search="0" searchadv="1" searchlist="0" height="1" width="20" />
  </panel>
  <panel-details panelid="1" dbtabledetails="MRP_CustomerProductDefinition" dbcolumndetails="CustomerID" label="客户产品信息">
    <field panelid="1" id="187" type="lov" typeid="5" label="物料名称" dbwherelov="View_MaterialNameAndCode.MType=5" dbcolumn="ProductID" dbcolumnread="Name1"
 dbtablelov="View_MaterialNameAndCode" dbcolumnreadlov="NameAndCode" maxlength="0" readonly="0" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="1" height="1" width="30" />
    <field id="168" panelid="1" type="text" typeid="5" label="客户物料编号" dbcolumn="CodeForCustomer" dbcolumnread="CodeForCustomer" maxlength="64" readonly="0" required="" optional="" fpos="100" search="1" searchadv="1" searchlist="" height="1" width="70" />
    <field id="161" panelid="1" type="formula" typeid="10" label="价格" 
           dbcolumn="(Select CurrentPrice from View_GetCurrentPrice where ProductID = T.ProductID AND CustomerID = T.CustomerID)" 
           dbcolumnread="Price" defaultvalue ="0" maxlength="4" readonly="1" required="0" optional="" fpos="30" search="0" searchadv="0" searchlist="1" height="1" width="20" />
    <field id="163" panelid="1" type="formula" typeid="10" label="币种"
          dbcolumn="(Select [View_Currency_List].[DisplayText] from View_GetCurrentPrice left join [View_Currency_List] on View_GetCurrentPrice.Tax=[View_Currency_List].ID  where ProductID = T.ProductID AND CustomerID = T.CustomerID)"
          dbcolumnread="CurrentCurency" maxlength="4" readonly="1" required="0" optional="" fpos="30" search="0" searchadv="0" searchlist="1" height="1" width="20" />
    <field id="164" panelid="1" type="formula" typeid="10" label="税金"
           dbcolumn="(Select View_Tax_List.[TaxCustomeType] from View_GetCurrentPrice left join View_Tax_List on View_GetCurrentPrice.Tax=View_Tax_List.ID  where ProductID = T.ProductID AND CustomerID = T.CustomerID)"
           dbcolumnread="CurrentTax" maxlength="4" readonly="1" required="0" optional="" fpos="30" search="0" searchadv="0" searchlist="1" height="1" width="20" />

  </panel-details>
</form>
